﻿CREATE TABLE [dbo].[MembraneOrder_Tbl] (
    [DPIHoldingID]     INT           IDENTITY (1, 1) NOT NULL,
    [LocationID]       INT           NULL,
    [UserID]           INT           NULL,
    [OrderRefNo]       NVARCHAR (50) NULL,
    [DelAddressID]     INT           NULL,
    [LatestDelWk]      INT           NULL,
    [SailTypeID]       INT           NULL,
    [Area]             FLOAT         NULL,
    [ReefPoints]       INT           NULL,
    [DesignFileName]   NVARCHAR (50) NULL,
    [DPContactID]      INT           NULL,
    [BoatType]         NVARCHAR (50) NULL,
    [FilmTypeID]       INT           NULL,
    [TopSurfaceID]     INT           NULL,
    [BotSurfaceID]     INT           NULL,
    [HeadYarnID]       INT           NULL,
    [TargetDPIID]      INT           NULL,
    [PrimYarnID]       INT           NULL,
    [SecYarnID]        INT           NULL,
    [Ratio]            NVARCHAR (50) NULL,
    [CreateDate]       NVARCHAR (50) NULL,
    [Notes]            NTEXT         NULL,
    [MarketID]         INT           NULL,
    [BoatTypeID]       INT           NULL,
    [LOA]              FLOAT         NULL,
    [Luff]             FLOAT         NULL,
    [LporFoot]         FLOAT         NULL,
    [Leech]            FLOAT         NULL,
    [TierID]           INT           NULL,
    [UsageID]          INT           NULL,
    [AWS]              INT           NULL,
    [QuoteSailTypeID]  INT           NULL,
    [GenericYarnID]    INT           NULL,
    [SavedFileRef]     NVARCHAR (50) NULL,
    [Delivered]        BIT           NULL,
    [DeliveredDate]    NVARCHAR (50) NULL,
    [DPConfirmationNo] NVARCHAR (50) NULL,
    [InvoiceNo]        NVARCHAR (50) NULL,
    [InvoiceDate]      NVARCHAR (50) NULL,
    [DPConfWk]         INT           NULL,
    [Remarks]          NVARCHAR (50) NULL,
    [AccountNum]       INT           NULL,
    [OrderID]          INT           NULL
);

